How to: Format patterns (cells) in Excel.
Solution:
Select 'Style...' from the 'Format' menu and click 'Modify...' from the 'Style' dialog box. Click the 'Patterns' tab from the 'Format Cells' dialog box and select the pattern and color for cells.
1) Select the cell(s) to be formatted with patterns.
2) Select the 'Format' menu and select 'Style...'. (The Style dialog box appears.)
3) Click 'Modify...'. (The Format Cells dialog box appears.)
4) Click the 'Patterns' tab.
5) Select a pattern from the 'Pattern' drop-down list box.
6) Click a color for the pattern from the 'Color' palette in the 'Cell Shading' group.
7) Click 'OK' from the 'Format Cells' dialog box.
8) Click 'OK' from the 'Style' dialog box.
